* Shootings and fatalities over time

clear all
set more off

import excel "shooting-map/nonfam_lat_lon.xlsx", clear firstrow
collapse (sum) fatalities (count) shootings=fatalities if !mi(year), by(year) fast

graph set window fontface Helvetica
set scheme lean2  // command for package info: net sj 4-3 gr0002_3

twoway conn fatalities year, name(fatal, replace) m(o) fysize(50) /*
    */ xlabel(1989(1)2014, angle(90) labsize(medsmall)) /*
    */ xtitle("", size(medsmall)) /*
    */ ytitle("Fatalities", size(medsmall)) /*
    */ ylabel(,labsize(medsmall) glcolor(gs6) glwidth(vvthin)) /*
    */ subtitle("Mass Shooting Fataliites", size(medsmall))

twoway conn shootings year, name(shoot, replace) m(o) fysize(50) /*
    */ xlabel(1989(1)2014, angle(90) labsize(medsmall)) /*
    */ xtitle("Year", size(medsmall)) /*
    */ ytitle("Number of Shootings", size(medsmall)) /*
    */ ylabel(,labsize(medsmall) glcolor(gs6) glwidth(vvthin)) /*
    */ subtitle("Mass Shooting Incidents", size(medsmall))

graph combine fatal shoot, col(1)
exit
